<?php
    $orderid = $_GET['order'];
    $query = "SELECT title, descr, customer, customer_mail, performer, performer_mail, updated_by, updated FROM crm_orders WHERE id='".$orderid."'";
    $result = mysql_query($query);
    while ($row = mysql_fetch_array($result))
    {
        echo "<div style='text-align: center'><h2>".$row['title']."</h2></div>";
        echo "<p>".$row['descr']."</p>";
        echo "<div id='customer'><b>Заказчик:</b> ".$row['customer']."
        <a href='mailto:'".$row['customer_mail']."'>".$row['customer_mail']."</a></div>";
        echo "<div id='performer'><b>Назначено:</b> ".$row['performer']."
        <a href='mailto:'".$row['performer_mail']."'>".$row['performer_mail']."</a></div>";
        echo "<div style='font-size: 10px'>Обновлено последний раз: ".$row['updated_by']." ".$row['updated']."</div>";
    }
?>